﻿CREATE TABLE [trUser].[tblCompanies] (
    [IDCompany]             BIGINT        IDENTITY (1, 1) NOT NULL,
    [Company]               NVARCHAR (50) NOT NULL,
    [CompanyTelephone]      NVARCHAR (30) NULL,
    [CompanyEmail]          NVARCHAR (50) NULL,
    [CompanyAddress]        NVARCHAR (50) NULL,
    [CompanyAddressLine2]   NVARCHAR (50) NULL,
    [IDCountry]             BIGINT        NULL,
    [IDState]               BIGINT        NULL,
    [IDCity]                BIGINT        NULL,
    [DateConfirmed]         DATETIME      NULL,
    [CreatedByIDUserDevice] BIGINT        NULL,
    [DateCreated]           DATETIME      CONSTRAINT [DF_tblCompanies_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]           DATETIME      NULL,
    [DateInactive]          DATETIME      NULL,
    CONSTRAINT [PK_tblCompanies] PRIMARY KEY CLUSTERED ([IDCompany] ASC)
);

